Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 5983 |
| Missing cells | 8618 |
| Missing cells (%) | 8.0% |
| Duplicate rows | 12 |
| Duplicate rows (%) | 0.2% |
| Total size in memory | 841.5 KiB |
| Average record size in memory | 144.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 10 |
| Dataset has 12 (0.2%) duplicate rows | Duplicates |
pickup_place has a high cardinality: 898 distinct values | High cardinality |
place_category has a high cardinality: 57 distinct values | High cardinality |
item_name has a high cardinality: 2277 distinct values | High cardinality |
item_category_name has a high cardinality: 767 distinct values | High cardinality |
how_long_it_took_to_order has a high cardinality: 2170 distinct values | High cardinality |
when_the_delivery_started has a high cardinality: 4867 distinct values | High cardinality |
when_the_courier_arrived_at_pickup has a high cardinality: 4446 distinct values | High cardinality |
when_the_courier_left_pickup has a high cardinality: 4428 distinct values | High cardinality |
when_the_courier_arrived_at_dropoff has a high cardinality: 4849 distinct values | High cardinality |
pickup_lat is highly correlated with pickup_lon and 1 other fields | High correlation |
pickup_lon is highly correlated with pickup_lat and 1 other fields | High correlation |
dropoff_lat is highly correlated with pickup_lat and 1 other fields | High correlation |
dropoff_lon is highly correlated with pickup_lon and 1 other fields | High correlation |
pickup_lat is highly correlated with pickup_lon and 1 other fields | High correlation |
pickup_lon is highly correlated with pickup_lat and 1 other fields | High correlation |
dropoff_lat is highly correlated with pickup_lat and 1 other fields | High correlation |
dropoff_lon is highly correlated with pickup_lon and 1 other fields | High correlation |
pickup_lat is highly correlated with dropoff_lat | High correlation |
dropoff_lat is highly correlated with pickup_lat | High correlation |
place_category is highly correlated with pickup_lat and 1 other fields | High correlation |
pickup_lat is highly correlated with place_category and 3 other fields | High correlation |
pickup_lon is highly correlated with place_category and 3 other fields | High correlation |
dropoff_lat is highly correlated with pickup_lat and 2 other fields | High correlation |
dropoff_lon is highly correlated with pickup_lat and 2 other fields | High correlation |
place_category has 883 (14.8%) missing values | Missing |
item_name has 1230 (20.6%) missing values | Missing |
item_quantity has 1230 (20.6%) missing values | Missing |
item_category_name has 1230 (20.6%) missing values | Missing |
how_long_it_took_to_order has 2945 (49.2%) missing values | Missing |
when_the_courier_arrived_at_pickup has 550 (9.2%) missing values | Missing |
when_the_courier_left_pickup has 550 (9.2%) missing values | Missing |
how_long_it_took_to_order is uniformly distributed | Uniform |
when_the_delivery_started is uniformly distributed | Uniform |
when_the_courier_arrived_at_pickup is uniformly distributed | Uniform |
when_the_courier_left_pickup is uniformly distributed | Uniform |
when_the_courier_arrived_at_dropoff is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2022-01-29 20:33:12.747810 |
|---|---|
| Analysis finished | 2022-01-29 20:33:27.222641 |
| Duration | 14.47 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
delivery_id
Real number (ℝ≥0)
| Distinct | 5214 |
|---|---|
| Distinct (%) | 87.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1379495.072 |
| Minimum | 1271706 |
|---|---|
| Maximum | 1491424 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.9 KiB |
Quantile statistics
| Minimum | 1271706 |
|---|---|
| 5-th percentile | 1281674 |
| Q1 | 1322792.5 |
| median | 1375689 |
| Q3 | 1436371 |
| 95-th percentile | 1480980.2 |
| Maximum | 1491424 |
| Range | 219718 |
| Interquartile range (IQR) | 113578.5 |
Descriptive statistics
| Standard deviation | 64593.9744 |
|---|---|
| Coefficient of variation (CV) | 0.04682436039 |
| Kurtosis | -1.221358888 |
| Mean | 1379495.072 |
| Median Absolute Deviation (MAD) | 56073 |
| Skewness | 0.08500157938 |
| Sum | 8253519014 |
| Variance | 4172381529 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1460296 | 5 | 0.1% |
| 1286826 | 4 | 0.1% |
| 1475127 | 4 | 0.1% |
| 1435427 | 4 | 0.1% |
| 1397032 | 4 | 0.1% |
| 1285292 | 4 | 0.1% |
| 1482492 | 4 | 0.1% |
| 1374803 | 4 | 0.1% |
| 1460699 | 4 | 0.1% |
| 1319971 | 4 | 0.1% |
| Other values (5204) | 5942 |
| Value | Count | Frequency (%) |
| 1271706 | 1 | |
| 1271751 | 1 | |
| 1271867 | 1 | |
| 1272279 | 1 | |
| 1272303 | 1 | |
| 1272363 | 1 | |
| 1272372 | 1 | |
| 1272382 | 1 | |
| 1272439 | 1 | |
| 1272451 | 1 |
| Value | Count | Frequency (%) |
| 1491424 | 2 | |
| 1491341 | 1 | |
| 1491147 | 1 | |
| 1491144 | 1 | |
| 1491110 | 1 | |
| 1491090 | 1 | |
| 1491029 | 1 | |
| 1490893 | 1 | |
| 1490865 | 1 | |
| 1490829 | 1 |
customer_id
Real number (ℝ≥0)
| Distinct | 3192 |
|---|---|
| Distinct (%) | 53.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 176472.5955 |
| Minimum | 242 |
|---|---|
| Maximum | 405547 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.9 KiB |
Quantile statistics
| Minimum | 242 |
|---|---|
| 5-th percentile | 44005 |
| Q1 | 77817 |
| median | 131093 |
| Q3 | 293381 |
| 95-th percentile | 377245.5 |
| Maximum | 405547 |
| Range | 405305 |
| Interquartile range (IQR) | 215564 |
Descriptive statistics
| Standard deviation | 116414.4878 |
|---|---|
| Coefficient of variation (CV) | 0.6596745942 |
| Kurtosis | -1.131648746 |
| Mean | 176472.5955 |
| Median Absolute Deviation (MAD) | 69479 |
| Skewness | 0.5926477933 |
| Sum | 1055835539 |
| Variance | 1.355233298 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 369272 | 28 | 0.5% |
| 52832 | 23 | 0.4% |
| 275689 | 17 | 0.3% |
| 125123 | 16 | 0.3% |
| 91817 | 16 | 0.3% |
| 58898 | 16 | 0.3% |
| 100889 | 14 | 0.2% |
| 115610 | 13 | 0.2% |
| 250494 | 13 | 0.2% |
| 301032 | 12 | 0.2% |
| Other values (3182) | 5815 |
| Value | Count | Frequency (%) |
| 242 | 1 | |
| 641 | 1 | |
| 1311 | 2 | |
| 1517 | 1 | |
| 2533 | 2 | |
| 3253 | 1 | |
| 4305 | 1 | |
| 5056 | 1 | |
| 5139 | 2 | |
| 5444 | 1 |
| Value | Count | Frequency (%) |
| 405547 | 1 | |
| 405334 | 1 | |
| 405233 | 1 | |
| 405147 | 1 | |
| 404787 | 1 | |
| 404786 | 1 | |
| 404649 | 1 | |
| 403994 | 1 | |
| 403833 | 1 | |
| 403796 | 1 |
courier_id
Real number (ℝ≥0)
| Distinct | 578 |
|---|---|
| Distinct (%) | 9.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102661.6025 |
| Minimum | 3296 |
|---|---|
| Maximum | 181543 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.9 KiB |
Quantile statistics
| Minimum | 3296 |
|---|---|
| 5-th percentile | 19432 |
| Q1 | 60761 |
| median | 113364 |
| Q3 | 143807 |
| 95-th percentile | 165848 |
| Maximum | 181543 |
| Range | 178247 |
| Interquartile range (IQR) | 83046 |
Descriptive statistics
| Standard deviation | 48607.21179 |
|---|---|
| Coefficient of variation (CV) | 0.4734702225 |
| Kurtosis | -1.093560594 |
| Mean | 102661.6025 |
| Median Absolute Deviation (MAD) | 39377 |
| Skewness | -0.399759354 |
| Sum | 614224368 |
| Variance | 2362661038 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99219 | 78 | 1.3% |
| 104533 | 76 | 1.3% |
| 142394 | 73 | 1.2% |
| 66416 | 62 | 1.0% |
| 61900 | 61 | 1.0% |
| 30743 | 58 | 1.0% |
| 3296 | 57 | 1.0% |
| 32580 | 56 | 0.9% |
| 20962 | 56 | 0.9% |
| 23359 | 54 | 0.9% |
| Other values (568) | 5352 |
| Value | Count | Frequency (%) |
| 3296 | 57 | |
| 3592 | 2 | < 0.1% |
| 3941 | 1 | < 0.1% |
| 5935 | 19 | 0.3% |
| 6458 | 2 | < 0.1% |
| 6715 | 1 | < 0.1% |
| 6873 | 35 | |
| 7833 | 28 | |
| 8625 | 15 | 0.3% |
| 9078 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 181543 | 3 | 0.1% |
| 179183 | 1 | < 0.1% |
| 178325 | 8 | |
| 177847 | 7 | |
| 177485 | 1 | < 0.1% |
| 177231 | 2 | < 0.1% |
| 177184 | 1 | < 0.1% |
| 177125 | 1 | < 0.1% |
| 176701 | 3 | 0.1% |
| 176250 | 1 | < 0.1% |
vehicle_type
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.9 KiB |
| bicycle | |
|---|---|
| car | |
| walker | 274 |
| van | 76 |
| scooter | 75 |
| Other values (2) | 69 |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.085575798 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | van |
|---|---|
| 2nd row | bicycle |
| 3rd row | bicycle |
| 4th row | bicycle |
| 5th row | bicycle |
Common Values
| Value | Count | Frequency (%) |
| bicycle | 4274 | |
| car | 1215 | 20.3% |
| walker | 274 | 4.6% |
| van | 76 | 1.3% |
| scooter | 75 | 1.3% |
| truck | 48 | 0.8% |
| motorcycle | 21 | 0.4% |
Length
Pie chart
| Value | Count | Frequency (%) |
| bicycle | 4274 | |
| car | 1215 | 20.3% |
| walker | 274 | 4.6% |
| van | 76 | 1.3% |
| scooter | 75 | 1.3% |
| truck | 48 | 0.8% |
| motorcycle | 21 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 898 |
|---|---|
| Distinct (%) | 15.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.9 KiB |
| Shake Shack | 311 |
|---|---|
| Momofuku Milk Bar | 186 |
| The Meatball Shop | 184 |
| Blue Ribbon Sushi | 151 |
| sweetgreen | 149 |
| Other values (893) |
Length
| Max length | 39 |
|---|---|
| Median length | 15 |
| Mean length | 15.57295671 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 457 ? |
|---|---|
| Unique (%) | 7.6% |
Sample
| 1st row | Melt Shop |
|---|---|
| 2nd row | Prince Street Pizza |
| 3rd row | Bareburger |
| 4th row | Juice Press |
| 5th row | Blue Ribbon Sushi |
Common Values
| Value | Count | Frequency (%) |
| Shake Shack | 311 | 5.2% |
| Momofuku Milk Bar | 186 | 3.1% |
| The Meatball Shop | 184 | 3.1% |
| Blue Ribbon Sushi | 151 | 2.5% |
| sweetgreen | 149 | 2.5% |
| Blue Ribbon Fried Chicken | 133 | 2.2% |
| Whole Foods Market | 119 | 2.0% |
| Parm | 102 | 1.7% |
| RedFarm Broadway | 93 | 1.6% |
| Mighty Quinn's BBQ | 90 | 1.5% |
| Other values (888) | 4465 |
Length
| Value | Count | Frequency (%) |
| sushi | 454 | 3.0% |
| blue | 437 | 2.9% |
| ribbon | 422 | 2.8% |
| bar | 410 | 2.7% |
| 343 | 2.2% | |
| the | 332 | 2.2% |
| shack | 314 | 2.1% |
| shake | 312 | 2.0% |
| momofuku | 281 | 1.8% |
| shop | 234 | 1.5% |
| Other values (1307) | 11734 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 57 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 883 |
| Missing (%) | 14.8% |
| Memory size | 46.9 KiB |
| Italian | |
|---|---|
| Burger | |
| Japanese | |
| American | |
| Chinese | |
| Other values (52) |
Length
| Max length | 21 |
|---|---|
| Median length | 7 |
| Mean length | 7.396470588 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | American |
|---|---|
| 2nd row | Pizza |
| 3rd row | Burger |
| 4th row | Juice Bar |
| 5th row | Japanese |
Common Values
| Value | Count | Frequency (%) |
| Italian | 504 | 8.4% |
| Burger | 454 | 7.6% |
| Japanese | 433 | 7.2% |
| American | 405 | 6.8% |
| Chinese | 332 | 5.5% |
| Dessert | 315 | 5.3% |
| Sushi | 253 | 4.2% |
| Salad | 206 | 3.4% |
| Grocery Store | 187 | 3.1% |
| Mexican | 178 | 3.0% |
| Other values (47) | 1833 | |
| (Missing) | 883 |
Length
| Value | Count | Frequency (%) |
| italian | 504 | 8.7% |
| burger | 454 | 7.8% |
| american | 443 | 7.6% |
| japanese | 433 | 7.5% |
| chinese | 332 | 5.7% |
| dessert | 315 | 5.4% |
| store | 315 | 5.4% |
| sushi | 253 | 4.4% |
| salad | 206 | 3.5% |
| grocery | 187 | 3.2% |
| Other values (56) | 2366 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2277 |
|---|---|
| Distinct (%) | 47.9% |
| Missing | 1230 |
| Missing (%) | 20.6% |
| Memory size | 46.9 KiB |
| Fries | 76 |
|---|---|
| Cheese Fries | 35 |
| Shackburger | 31 |
| Chicken | 30 |
| Shack Burger | 29 |
| Other values (2272) |
Length
| Max length | 79 |
|---|---|
| Median length | 15 |
| Mean length | 16.67220703 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1502 ? |
|---|---|
| Unique (%) | 31.6% |
Sample
| 1st row | Lemonade |
|---|---|
| 2nd row | Neapolitan Rice Balls |
| 3rd row | Bare Sodas |
| 4th row | OMG! My Favorite Juice! |
| 5th row | Spicy Tuna & Tempura Flakes |
Common Values
| Value | Count | Frequency (%) |
| Fries | 76 | 1.3% |
| Cheese Fries | 35 | 0.6% |
| Shackburger | 31 | 0.5% |
| Chicken | 30 | 0.5% |
| Shack Burger | 29 | 0.5% |
| Hamburger | 26 | 0.4% |
| B'day Cake Truffles | 26 | 0.4% |
| Classic Beef | 24 | 0.4% |
| ShackBurger | 24 | 0.4% |
| Cheeseburger | 23 | 0.4% |
| Other values (2267) | 4429 | |
| (Missing) | 1230 | 20.6% |
Length
| Value | Count | Frequency (%) |
| chicken | 335 | 2.6% |
| 319 | 2.5% | |
| spicy | 196 | 1.5% |
| salad | 187 | 1.5% |
| fries | 178 | 1.4% |
| roll | 138 | 1.1% |
| chocolate | 116 | 0.9% |
| cheese | 114 | 0.9% |
| pork | 114 | 0.9% |
| tuna | 108 | 0.8% |
| Other values (2149) | 10973 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1230 |
| Missing (%) | 20.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.248264254 |
| Minimum | 1 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.785903823 |
|---|---|
| Coefficient of variation (CV) | 0.6295973152 |
| Kurtosis | 102.754254 |
| Mean | 1.248264254 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.708421156 |
| Sum | 5933 |
| Variance | 0.617644819 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 3980 | |
| 2 | 570 | 9.5% |
| 3 | 112 | 1.9% |
| 4 | 54 | 0.9% |
| 6 | 14 | 0.2% |
| 5 | 13 | 0.2% |
| 8 | 4 | 0.1% |
| 15 | 3 | 0.1% |
| 7 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| (Missing) | 1230 | 20.6% |
| Value | Count | Frequency (%) |
| 1 | 3980 | |
| 2 | 570 | 9.5% |
| 3 | 112 | 1.9% |
| 4 | 54 | 0.9% |
| 5 | 13 | 0.2% |
| 6 | 14 | 0.2% |
| 7 | 1 | < 0.1% |
| 8 | 4 | 0.1% |
| 12 | 1 | < 0.1% |
| 15 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 16 | 1 | < 0.1% |
| 15 | 3 | 0.1% |
| 12 | 1 | < 0.1% |
| 8 | 4 | 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 14 | 0.2% |
| 5 | 13 | 0.2% |
| 4 | 54 | 0.9% |
| 3 | 112 | 1.9% |
| 2 | 570 |
| Distinct | 767 |
|---|---|
| Distinct (%) | 16.1% |
| Missing | 1230 |
| Missing (%) | 20.6% |
| Memory size | 46.9 KiB |
| Sides | 193 |
|---|---|
| Burgers | 148 |
| Appetizers | 145 |
| Sandwiches | 123 |
| Fries | 111 |
| Other values (762) |
Length
| Max length | 53 |
|---|---|
| Median length | 10 |
| Mean length | 11.5480749 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 315 ? |
|---|---|
| Unique (%) | 6.6% |
Sample
| 1st row | Beverages |
|---|---|
| 2nd row | Munchables |
| 3rd row | Drinks |
| 4th row | Cold Pressed Juices |
| 5th row | Maki (Special Rolls) |
Common Values
| Value | Count | Frequency (%) |
| Sides | 193 | 3.2% |
| Burgers | 148 | 2.5% |
| Appetizers | 145 | 2.4% |
| Sandwiches | 123 | 2.1% |
| Fries | 111 | 1.9% |
| Salads | 103 | 1.7% |
| Cookies | 86 | 1.4% |
| Signatures | 82 | 1.4% |
| Drinks | 69 | 1.2% |
| Naked Balls | 62 | 1.0% |
| Other values (757) | 3631 | |
| (Missing) | 1230 | 20.6% |
Length
| Value | Count | Frequency (%) |
| 381 | 4.4% | |
| sides | 280 | 3.2% |
| appetizers | 197 | 2.3% |
| rolls | 196 | 2.2% |
| sandwiches | 185 | 2.1% |
| salads | 182 | 2.1% |
| dinner | 170 | 1.9% |
| burgers | 169 | 1.9% |
| the | 128 | 1.5% |
| special | 122 | 1.4% |
| Other values (681) | 6733 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2170 |
|---|---|
| Distinct (%) | 71.4% |
| Missing | 2945 |
| Missing (%) | 49.2% |
| Memory size | 46.9 KiB |
| 03:20.2 | 8 |
|---|---|
| 04:28.8 | 6 |
| 06:36.3 | 6 |
| 04:54.4 | 6 |
| 04:34.3 | 5 |
| Other values (2165) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1544 ? |
|---|---|
| Unique (%) | 50.8% |
Sample
| 1st row | 19:58.6 |
|---|---|
| 2nd row | 25:09.1 |
| 3rd row | 06:44.5 |
| 4th row | 03:45.0 |
| 5th row | 07:14.3 |
Common Values
| Value | Count | Frequency (%) |
| 03:20.2 | 8 | 0.1% |
| 04:28.8 | 6 | 0.1% |
| 06:36.3 | 6 | 0.1% |
| 04:54.4 | 6 | 0.1% |
| 04:34.3 | 5 | 0.1% |
| 07:08.8 | 5 | 0.1% |
| 03:53.2 | 5 | 0.1% |
| 04:45.2 | 5 | 0.1% |
| 05:38.2 | 5 | 0.1% |
| 05:17.8 | 5 | 0.1% |
| Other values (2160) | 2982 | |
| (Missing) | 2945 |
Length
| Value | Count | Frequency (%) |
| 03:20.2 | 8 | 0.3% |
| 04:54.4 | 6 | 0.2% |
| 04:28.8 | 6 | 0.2% |
| 06:36.3 | 6 | 0.2% |
| 05:17.8 | 5 | 0.2% |
| 04:34.3 | 5 | 0.2% |
| 04:21.4 | 5 | 0.2% |
| 05:52.9 | 5 | 0.2% |
| 06:31.5 | 5 | 0.2% |
| 05:38.2 | 5 | 0.2% |
| Other values (2160) | 2982 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1210 |
|---|---|
| Distinct (%) | 20.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.74142455 |
| Minimum | 40.66561086 |
|---|---|
| Maximum | 40.8180821 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.9 KiB |
Quantile statistics
| Minimum | 40.66561086 |
|---|---|
| 5-th percentile | 40.71527933 |
| Q1 | 40.72434 |
| median | 40.73567676 |
| Q3 | 40.7587261 |
| 95-th percentile | 40.7821167 |
| Maximum | 40.8180821 |
| Range | 0.15247124 |
| Interquartile range (IQR) | 0.0343861 |
Descriptive statistics
| Standard deviation | 0.02283251627 |
|---|---|
| Coefficient of variation (CV) | 0.000560425084 |
| Kurtosis | 0.1879280573 |
| Mean | 40.74142455 |
| Median Absolute Deviation (MAD) | 0.01265693 |
| Skewness | 0.4966340253 |
| Sum | 243755.9431 |
| Variance | 0.0005213237994 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.72434 | 159 | 2.7% |
| 40.72610966 | 151 | 2.5% |
| 40.73179547 | 113 | 1.9% |
| 40.71527933 | 109 | 1.8% |
| 40.72301983 | 102 | 1.7% |
| 40.7821167 | 93 | 1.6% |
| 40.74507859 | 87 | 1.5% |
| 40.72751895 | 86 | 1.4% |
| 40.7291104 | 74 | 1.2% |
| 40.73567676 | 68 | 1.1% |
| Other values (1200) | 4941 |
| Value | Count | Frequency (%) |
| 40.66561086 | 5 | |
| 40.67176012 | 2 | < 0.1% |
| 40.67347806 | 3 | 0.1% |
| 40.67425095 | 9 | |
| 40.67469097 | 1 | < 0.1% |
| 40.675263 | 1 | < 0.1% |
| 40.6753166 | 6 | |
| 40.67610552 | 1 | < 0.1% |
| 40.67768312 | 5 | |
| 40.67790077 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.8180821 | 17 | |
| 40.81535397 | 1 | < 0.1% |
| 40.81133225 | 1 | < 0.1% |
| 40.80707234 | 1 | < 0.1% |
| 40.80625721 | 1 | < 0.1% |
| 40.805839 | 1 | < 0.1% |
| 40.80583493 | 1 | < 0.1% |
| 40.80504518 | 1 | < 0.1% |
| 40.80482529 | 1 | < 0.1% |
| 40.80451853 | 1 | < 0.1% |
| Distinct | 1178 |
|---|---|
| Distinct (%) | 19.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.98710128 |
| Minimum | -74.01583672 |
|---|---|
| Maximum | -73.92097967 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 5983 |
| Negative (%) | 100.0% |
| Memory size | 46.9 KiB |
Quantile statistics
| Minimum | -74.01583672 |
|---|---|
| 5-th percentile | -74.0086925 |
| Q1 | -73.99663005 |
| median | -73.98868203 |
| Q3 | -73.9807391 |
| 95-th percentile | -73.95509005 |
| Maximum | -73.92097967 |
| Range | 0.09485705 |
| Interquartile range (IQR) | 0.01589095 |
Descriptive statistics
| Standard deviation | 0.01489569141 |
|---|---|
| Coefficient of variation (CV) | -0.0002013282201 |
| Kurtosis | 0.4094801605 |
| Mean | -73.98710128 |
| Median Absolute Deviation (MAD) | 0.00794802 |
| Skewness | 0.7404730568 |
| Sum | -442664.8269 |
| Variance | 0.0002218816226 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.99096 | 159 | 2.7% |
| -74.00249186 | 151 | 2.5% |
| -73.98567259 | 113 | 1.9% |
| -74.01486039 | 109 | 1.8% |
| -73.995854 | 102 | 1.7% |
| -73.9807391 | 93 | 1.6% |
| -73.98882151 | 87 | 1.5% |
| -73.9886713 | 86 | 1.4% |
| -73.98424546 | 74 | 1.2% |
| -73.99382953 | 68 | 1.1% |
| Other values (1168) | 4941 |
| Value | Count | Frequency (%) |
| -74.01583672 | 1 | < 0.1% |
| -74.01544645 | 3 | 0.1% |
| -74.01486039 | 109 | |
| -74.01472344 | 1 | < 0.1% |
| -74.01462589 | 1 | < 0.1% |
| -74.01345529 | 1 | < 0.1% |
| -74.01306509 | 5 | 0.1% |
| -74.01235355 | 15 | 0.3% |
| -74.01177049 | 1 | < 0.1% |
| -74.01175103 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.92097967 | 1 | < 0.1% |
| -73.928287 | 1 | < 0.1% |
| -73.93324098 | 1 | < 0.1% |
| -73.934196 | 5 | |
| -73.93542815 | 1 | < 0.1% |
| -73.93992 | 1 | < 0.1% |
| -73.94058885 | 2 | < 0.1% |
| -73.940994 | 1 | < 0.1% |
| -73.94206524 | 1 | < 0.1% |
| -73.94356236 | 4 |
| Distinct | 2841 |
|---|---|
| Distinct (%) | 47.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.74421648 |
| Minimum | 40.64935581 |
|---|---|
| Maximum | 40.848324 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.9 KiB |
Quantile statistics
| Minimum | 40.64935581 |
|---|---|
| 5-th percentile | 40.70855722 |
| Q1 | 40.72530703 |
| median | 40.74042351 |
| Q3 | 40.7638848 |
| 95-th percentile | 40.7862259 |
| Maximum | 40.848324 |
| Range | 0.19896819 |
| Interquartile range (IQR) | 0.03857777 |
Descriptive statistics
| Standard deviation | 0.02525145915 |
|---|---|
| Coefficient of variation (CV) | 0.0006197556692 |
| Kurtosis | 0.1228005566 |
| Mean | 40.74421648 |
| Median Absolute Deviation (MAD) | 0.01709401 |
| Skewness | 0.2672815271 |
| Sum | 243772.6472 |
| Variance | 0.0006376361892 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.727405 | 42 | 0.7% |
| 40.7324282 | 29 | 0.5% |
| 40.767651 | 28 | 0.5% |
| 40.7236764 | 23 | 0.4% |
| 40.7233295 | 22 | 0.4% |
| 40.7467644 | 22 | 0.4% |
| 40.724455 | 19 | 0.3% |
| 40.7202117 | 19 | 0.3% |
| 40.7389323 | 18 | 0.3% |
| 40.778028 | 18 | 0.3% |
| Other values (2831) | 5743 |
| Value | Count | Frequency (%) |
| 40.64935581 | 2 | |
| 40.64940367 | 1 | < 0.1% |
| 40.649574 | 3 | |
| 40.65214519 | 2 | |
| 40.66688836 | 1 | < 0.1% |
| 40.66807 | 1 | < 0.1% |
| 40.668481 | 1 | < 0.1% |
| 40.66927311 | 1 | < 0.1% |
| 40.670283 | 1 | < 0.1% |
| 40.670584 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.848324 | 1 | < 0.1% |
| 40.837404 | 1 | < 0.1% |
| 40.83602938 | 1 | < 0.1% |
| 40.8351339 | 3 | |
| 40.8288547 | 1 | < 0.1% |
| 40.826658 | 1 | < 0.1% |
| 40.8260054 | 1 | < 0.1% |
| 40.82371293 | 1 | < 0.1% |
| 40.8235529 | 2 | |
| 40.820046 | 1 | < 0.1% |
| Distinct | 2839 |
|---|---|
| Distinct (%) | 47.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.98576547 |
| Minimum | -74.0176786 |
|---|---|
| Maximum | -73.92412352 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 5983 |
| Negative (%) | 100.0% |
| Memory size | 46.9 KiB |
Quantile statistics
| Minimum | -74.0176786 |
|---|---|
| 5-th percentile | -74.00964682 |
| Q1 | -74.000297 |
| median | -73.98927961 |
| Q3 | -73.97469635 |
| 95-th percentile | -73.95276784 |
| Maximum | -73.92412352 |
| Range | 0.09355508 |
| Interquartile range (IQR) | 0.02560065 |
Descriptive statistics
| Standard deviation | 0.01805950314 |
|---|---|
| Coefficient of variation (CV) | -0.0002440942933 |
| Kurtosis | -0.3696332607 |
| Mean | -73.98576547 |
| Median Absolute Deviation (MAD) | 0.01258029 |
| Skewness | 0.598600561 |
| Sum | -442656.8348 |
| Variance | 0.0003261456535 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.991802 | 42 | 0.7% |
| -74.0080594 | 29 | 0.5% |
| -73.966875 | 28 | 0.5% |
| -74.0107235 | 23 | 0.4% |
| -73.9903014 | 22 | 0.4% |
| -73.9915018 | 22 | 0.4% |
| -74.0021308 | 19 | 0.3% |
| -73.953851 | 18 | 0.3% |
| -74.0088234 | 18 | 0.3% |
| -74.0040761 | 17 | 0.3% |
| Other values (2829) | 5745 |
| Value | Count | Frequency (%) |
| -74.0176786 | 3 | 0.1% |
| -74.0172878 | 1 | < 0.1% |
| -74.0171494 | 1 | < 0.1% |
| -74.0171217 | 1 | < 0.1% |
| -74.01706219 | 1 | < 0.1% |
| -74.0169647 | 1 | < 0.1% |
| -74.016943 | 8 | |
| -74.0168879 | 2 | < 0.1% |
| -74.016875 | 2 | < 0.1% |
| -74.01671467 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.92412352 | 2 | < 0.1% |
| -73.9248061 | 1 | < 0.1% |
| -73.925819 | 4 | |
| -73.927723 | 1 | < 0.1% |
| -73.9283556 | 1 | < 0.1% |
| -73.928499 | 4 | |
| -73.929931 | 1 | < 0.1% |
| -73.93111168 | 1 | < 0.1% |
| -73.9341815 | 2 | < 0.1% |
| -73.93488 | 6 |
| Distinct | 4867 |
|---|---|
| Distinct (%) | 81.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.9 KiB |
| 40:37.6 | 6 |
|---|---|
| 09:25.3 | 5 |
| 14:29.8 | 5 |
| 47:57.8 | 5 |
| 55:46.1 | 5 |
| Other values (4862) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 3951 ? |
|---|---|
| Unique (%) | 66.0% |
Sample
| 1st row | 51:59.9 |
|---|---|
| 2nd row | 58:58.7 |
| 3rd row | 39:52.7 |
| 4th row | 54:11.5 |
| 5th row | 07:18.5 |
Common Values
| Value | Count | Frequency (%) |
| 40:37.6 | 6 | 0.1% |
| 09:25.3 | 5 | 0.1% |
| 14:29.8 | 5 | 0.1% |
| 47:57.8 | 5 | 0.1% |
| 55:46.1 | 5 | 0.1% |
| 46:45.8 | 5 | 0.1% |
| 26:28.2 | 4 | 0.1% |
| 15:42.8 | 4 | 0.1% |
| 56:43.9 | 4 | 0.1% |
| 37:08.2 | 4 | 0.1% |
| Other values (4857) | 5936 |
Length
| Value | Count | Frequency (%) |
| 40:37.6 | 6 | 0.1% |
| 14:29.8 | 5 | 0.1% |
| 47:57.8 | 5 | 0.1% |
| 55:46.1 | 5 | 0.1% |
| 46:45.8 | 5 | 0.1% |
| 09:25.3 | 5 | 0.1% |
| 59:43.0 | 4 | 0.1% |
| 29:24.1 | 4 | 0.1% |
| 31:28.2 | 4 | 0.1% |
| 19:55.9 | 4 | 0.1% |
| Other values (4857) | 5936 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4446 |
|---|---|
| Distinct (%) | 81.8% |
| Missing | 550 |
| Missing (%) | 9.2% |
| Memory size | 46.9 KiB |
| 03:22.3 | 6 |
|---|---|
| 18:24.3 | 5 |
| 30:47.0 | 5 |
| 06:24.1 | 5 |
| 40:36.5 | 5 |
| Other values (4441) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 3638 ? |
|---|---|
| Unique (%) | 67.0% |
Sample
| 1st row | 26:02.1 |
|---|---|
| 2nd row | 37:18.8 |
| 3rd row | 04:17.8 |
| 4th row | 14:42.7 |
| 5th row | 18:50.0 |
Common Values
| Value | Count | Frequency (%) |
| 03:22.3 | 6 | 0.1% |
| 18:24.3 | 5 | 0.1% |
| 30:47.0 | 5 | 0.1% |
| 06:24.1 | 5 | 0.1% |
| 40:36.5 | 5 | 0.1% |
| 01:08.8 | 4 | 0.1% |
| 59:48.5 | 4 | 0.1% |
| 46:31.8 | 4 | 0.1% |
| 14:06.2 | 4 | 0.1% |
| 52:15.5 | 4 | 0.1% |
| Other values (4436) | 5387 | |
| (Missing) | 550 | 9.2% |
Length
| Value | Count | Frequency (%) |
| 03:22.3 | 6 | 0.1% |
| 30:47.0 | 5 | 0.1% |
| 06:24.1 | 5 | 0.1% |
| 40:36.5 | 5 | 0.1% |
| 18:24.3 | 5 | 0.1% |
| 45:18.3 | 4 | 0.1% |
| 00:38.6 | 4 | 0.1% |
| 54:01.8 | 4 | 0.1% |
| 32:06.7 | 4 | 0.1% |
| 15:13.6 | 4 | 0.1% |
| Other values (4436) | 5387 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4428 |
|---|---|
| Distinct (%) | 81.5% |
| Missing | 550 |
| Missing (%) | 9.2% |
| Memory size | 46.9 KiB |
| 37:43.3 | 7 |
|---|---|
| 37:15.6 | 7 |
| 15:44.7 | 6 |
| 26:51.9 | 5 |
| 35:41.9 | 5 |
| Other values (4423) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 3617 ? |
|---|---|
| Unique (%) | 66.6% |
Sample
| 1st row | 48:23.1 |
|---|---|
| 2nd row | 59:10.0 |
| 3rd row | 16:37.9 |
| 4th row | 25:19.4 |
| 5th row | 27:10.6 |
Common Values
| Value | Count | Frequency (%) |
| 37:43.3 | 7 | 0.1% |
| 37:15.6 | 7 | 0.1% |
| 15:44.7 | 6 | 0.1% |
| 26:51.9 | 5 | 0.1% |
| 35:41.9 | 5 | 0.1% |
| 43:52.0 | 5 | 0.1% |
| 38:07.4 | 5 | 0.1% |
| 50:07.4 | 4 | 0.1% |
| 24:51.9 | 4 | 0.1% |
| 26:33.7 | 4 | 0.1% |
| Other values (4418) | 5381 | |
| (Missing) | 550 | 9.2% |
Length
| Value | Count | Frequency (%) |
| 37:43.3 | 7 | 0.1% |
| 37:15.6 | 7 | 0.1% |
| 15:44.7 | 6 | 0.1% |
| 26:51.9 | 5 | 0.1% |
| 35:41.9 | 5 | 0.1% |
| 43:52.0 | 5 | 0.1% |
| 38:07.4 | 5 | 0.1% |
| 27:38.1 | 4 | 0.1% |
| 40:05.2 | 4 | 0.1% |
| 02:29.8 | 4 | 0.1% |
| Other values (4418) | 5381 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4849 |
|---|---|
| Distinct (%) | 81.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.9 KiB |
| 35:36.9 | 5 |
|---|---|
| 39:07.3 | 5 |
| 46:58.5 | 5 |
| 41:56.0 | 5 |
| 48:41.9 | 5 |
| Other values (4844) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 3932 ? |
|---|---|
| Unique (%) | 65.7% |
Sample
| 1st row | 52:06.3 |
|---|---|
| 2nd row | 59:22.9 |
| 3rd row | 04:40.6 |
| 4th row | 32:38.1 |
| 5th row | 48:27.2 |
Common Values
| Value | Count | Frequency (%) |
| 35:36.9 | 5 | 0.1% |
| 39:07.3 | 5 | 0.1% |
| 46:58.5 | 5 | 0.1% |
| 41:56.0 | 5 | 0.1% |
| 48:41.9 | 5 | 0.1% |
| 26:44.9 | 5 | 0.1% |
| 24:46.1 | 5 | 0.1% |
| 25:14.6 | 4 | 0.1% |
| 30:36.2 | 4 | 0.1% |
| 25:49.0 | 4 | 0.1% |
| Other values (4839) | 5936 |
Length
| Value | Count | Frequency (%) |
| 35:36.9 | 5 | 0.1% |
| 46:58.5 | 5 | 0.1% |
| 41:56.0 | 5 | 0.1% |
| 48:41.9 | 5 | 0.1% |
| 26:44.9 | 5 | 0.1% |
| 24:46.1 | 5 | 0.1% |
| 39:07.3 | 5 | 0.1% |
| 01:29.0 | 4 | 0.1% |
| 57:38.7 | 4 | 0.1% |
| 53:41.2 | 4 | 0.1% |
| Other values (4839) | 5936 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| delivery_id | customer_id | courier_id | vehicle_type | pickup_place | place_category | item_name | item_quantity | item_category_name | how_long_it_took_to_order | pickup_lat | pickup_lon | dropoff_lat | dropoff_lon | when_the_delivery_started | when_the_courier_arrived_at_pickup | when_the_courier_left_pickup | when_the_courier_arrived_at_dropoff | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1457973 | 327168 | 162381 | van | Melt Shop | American | Lemonade | 1.0 | Beverages | 19:58.6 | 40.744607 | -73.990742 | 40.752073 | -73.985370 | 51:59.9 | NaN | NaN | 52:06.3 |
| 1 | 1377056 | 64452 | 104533 | bicycle | Prince Street Pizza | Pizza | Neapolitan Rice Balls | 3.0 | Munchables | 25:09.1 | 40.723080 | -73.994615 | 40.719722 | -73.991858 | 58:58.7 | 26:02.1 | 48:23.1 | 59:22.9 |
| 2 | 1476547 | 83095 | 132725 | bicycle | Bareburger | Burger | Bare Sodas | 1.0 | Drinks | 06:44.5 | 40.728478 | -73.998392 | 40.728606 | -73.995143 | 39:52.7 | 37:18.8 | 59:10.0 | 04:40.6 |
| 3 | 1485494 | 271149 | 157175 | bicycle | Juice Press | Juice Bar | OMG! My Favorite Juice! | 1.0 | Cold Pressed Juices | NaN | 40.738868 | -74.002747 | 40.751257 | -74.005634 | 54:11.5 | 04:17.8 | 16:37.9 | 32:38.1 |
| 4 | 1327707 | 122609 | 118095 | bicycle | Blue Ribbon Sushi | Japanese | Spicy Tuna & Tempura Flakes | 2.0 | Maki (Special Rolls) | 03:45.0 | 40.726110 | -74.002492 | 40.709323 | -74.015867 | 07:18.5 | 14:42.7 | 25:19.4 | 48:27.2 |
| 5 | 1423142 | 75169 | 91932 | bicycle | Tamarind TriBeCa | Indian | Dum Aloo Gobi | 1.0 | Vegetarian Specialties | 07:14.3 | 40.719269 | -74.008750 | 40.725678 | -74.000618 | 56:36.3 | 18:50.0 | 27:10.6 | 36:53.8 |
| 6 | 1334106 | 101347 | 124897 | bicycle | The Loop | Sushi | Spicy Tuna Roll | 1.0 | Classic Roll & Hand Roll | 04:49.4 | 40.734858 | -73.986093 | 40.738368 | -74.000105 | 08:55.5 | 07:16.0 | 29:24.5 | 40:01.7 |
| 7 | 1311619 | 59161 | 79847 | bicycle | Insomnia Cookies | Bakery | Chocolate Chunk | 2.0 | Cookies and Brownies | NaN | 40.729791 | -74.000589 | 40.734703 | -73.998206 | 20:09.3 | 17:35.7 | 03:24.4 | 09:16.6 |
| 8 | 1487674 | 55375 | 181543 | bicycle | Cafe Zaiya | NaN | NaN | NaN | NaN | NaN | 40.729357 | -73.990156 | 40.719758 | -73.985011 | 49:48.3 | 55:32.4 | 01:22.2 | 10:44.7 |
| 9 | 1417206 | 153816 | 157415 | car | Shake Shack | Burger | Shackburger | 1.0 | Burgers | NaN | 40.758457 | -73.989140 | 40.743613 | -73.977684 | 18:37.9 | 20:14.4 | 47:03.6 | 59:26.1 |
Last rows
| delivery_id | customer_id | courier_id | vehicle_type | pickup_place | place_category | item_name | item_quantity | item_category_name | how_long_it_took_to_order | pickup_lat | pickup_lon | dropoff_lat | dropoff_lon | when_the_delivery_started | when_the_courier_arrived_at_pickup | when_the_courier_left_pickup | when_the_courier_arrived_at_dropoff | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5973 | 1379953 | 127103 | 69993 | bicycle | The Grey Dog - University | Coffee | Organic Raw Veggies | 1.0 | Small Plates | 04:34.4 | 40.733787 | -73.993035 | 40.736760 | -73.982048 | 35:30.0 | 43:14.4 | 50:04.6 | 57:28.4 |
| 5974 | 1379770 | 243775 | 138061 | car | Postmates Liquor Store | Shop | Raventos I Blanc L'Hereu Reserva Brut Cava - 2011 | 1.0 | Sparkling | NaN | 40.779598 | -73.947388 | 40.723861 | -73.996981 | 08:33.1 | 22:28.4 | 26:54.0 | 57:58.4 |
| 5975 | 1475459 | 303211 | 156557 | car | Big Nick's Burgers & Pizza | Pizza | Chicken Fingers | 1.0 | Appetizers & Side Orders | 05:11.1 | 40.776767 | -73.979120 | 40.793834 | -73.941521 | 47:25.9 | 48:56.2 | 11:46.1 | 25:02.1 |
| 5976 | 1300266 | 135451 | 36664 | bicycle | Juice Generation | Juice Bar | Red Dragon Fruit | 1.0 | Smoothies | NaN | 40.777598 | -73.979528 | 40.778493 | -73.986542 | 48:36.9 | 54:59.5 | 06:07.4 | 13:57.9 |
| 5977 | 1303444 | 228541 | 148268 | bicycle | RedFarm Hudson | Chinese | Soft & Crunchy Vegetable Fried Rice | 1.0 | Rice & Noodles | 03:32.1 | 40.734214 | -74.006202 | 40.732425 | -73.996269 | 22:52.5 | 35:32.0 | 59:22.6 | 07:20.0 |
| 5978 | 1360750 | 378035 | 151467 | bicycle | Five Guys Burgers and Fries | Burger | Cheeseburger | 1.0 | Burgers | NaN | 40.804404 | -73.966430 | 40.818637 | -73.939241 | 30:25.6 | 41:09.4 | 53:28.3 | 10:19.3 |
| 5979 | 1348697 | 96943 | 3296 | bicycle | Cafe Mogador | Middle Eastern | Vegetarian | 1.0 | Cous Cous | NaN | 40.727293 | -73.984517 | 40.725938 | -73.980550 | 37:42.6 | 44:21.3 | 54:16.4 | 00:43.0 |
| 5980 | 1274438 | 355090 | 153113 | bicycle | Shake Shack | Burger | Fries | 1.0 | Fries | NaN | 40.780826 | -73.976483 | 40.763573 | -73.973503 | 12:57.0 | 29:59.8 | 52:19.8 | 16:52.7 |
| 5981 | 1470282 | 400983 | 142140 | car | Omai | Vietnamese | Ca Tim | 1.0 | Appetizers | 02:17.3 | 40.744408 | -74.002891 | 40.734609 | -74.006405 | 25:03.6 | 22:37.8 | 39:25.8 | 50:45.3 |
| 5982 | 1357449 | 128517 | 134189 | car | RedFarm Broadway | Chinese | Pan-Fried Pork Buns (4) | 1.0 | Dim Sum | 09:25.3 | 40.782117 | -73.980739 | 40.732714 | -73.995040 | 30:44.5 | 40:22.5 | 06:02.1 | 31:54.4 |
Most frequently occurring
| delivery_id | customer_id | courier_id | vehicle_type | pickup_place | place_category | item_name | item_quantity | item_category_name | how_long_it_took_to_order | pickup_lat | pickup_lon | dropoff_lat | dropoff_lon | when_the_delivery_started | when_the_courier_arrived_at_pickup | when_the_courier_left_pickup | when_the_courier_arrived_at_dropoff | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1274791 | 59749 | 61162 | bicycle | Bareburger | Burger | Barest Burger | 1.0 | Bareburgers | 04:00.5 | 40.768489 | -73.955182 | 40.784797 | -73.953658 | 06:44.9 | 31:56.0 | 37:43.3 | 51:34.2 | 2 |
| 1 | 1279990 | 85091 | 105178 | bicycle | The Meatball Shop | Italian | Ice Cream Sandwich | 1.0 | Desserts | 03:11.4 | 40.771491 | -73.956334 | 40.779800 | -73.957061 | 55:27.1 | 11:42.5 | 22:33.3 | 46:35.1 | 2 |
| 2 | 1280728 | 127149 | 57496 | bicycle | P.J. Clarke's | American | Simply On A Bun | 1.0 | P.J. Clarke's Hamburgers | 16:31.3 | 40.758939 | -73.968531 | 40.766654 | -73.952847 | 15:18.2 | 37:50.8 | 50:58.8 | 03:28.5 | 2 |
| 3 | 1319722 | 149234 | 139558 | bicycle | Maimonide of Brooklyn | Vegetarian | Mob Cheeseburger Deluxe | 1.0 | Entrees | 06:24.0 | 40.685201 | -73.980211 | 40.649574 | -73.964392 | 57:37.7 | 08:42.9 | 19:32.5 | 37:39.5 | 2 |
| 4 | 1341790 | 373689 | 152676 | bicycle | Bareburger | Burger | Country Bacon | 1.0 | Bareburgers | 21:38.7 | 40.768489 | -73.955182 | 40.765698 | -73.954975 | 59:28.3 | 19:47.3 | 40:35.9 | 46:48.6 | 2 |
| 5 | 1343449 | 17495 | 138057 | car | The Meatball Shop | Italian | Ice Cream Sandwich | 1.0 | Desserts | 02:26.4 | 40.721545 | -73.988842 | 40.709410 | -74.006714 | 38:33.2 | 49:06.1 | 00:26.2 | 19:37.7 | 2 |
| 6 | 1349702 | 42781 | 65763 | bicycle | 2nd Ave Deli | Deli | Potato Knish | 2.0 | Franks and Knishes | 06:54.4 | 40.745299 | -73.979138 | 40.738913 | -73.987760 | 52:26.8 | 21:08.3 | 40:57.1 | 49:50.8 | 2 |
| 7 | 1363244 | 100738 | 30905 | car | The Meatball Shop | Italian | Classic Beef | 1.0 | Naked Balls | 09:06.4 | 40.745963 | -74.001697 | 40.747098 | -73.986641 | 44:35.3 | 05:45.7 | 11:05.5 | 24:17.0 | 2 |
| 8 | 1423447 | 391860 | 167596 | bicycle | Lucky's Famous Burgers | Burger | Lucky Shake | 1.0 | Shakes | 10:07.6 | 40.723331 | -73.989531 | 40.720472 | -73.989326 | 24:39.8 | 56:48.5 | 03:05.0 | 06:07.0 | 2 |
| 9 | 1428278 | 301695 | 62487 | car | sweetgreen | Salad | Harvest Bowl | 1.0 | Signatures | 06:17.3 | 40.745079 | -73.988822 | 40.750667 | -73.986099 | 32:27.4 | 59:13.6 | 09:07.6 | 22:30.5 | 2 |